[dbo].[BAEImisNameSecurityGroupsSave]
SQLServer
>
iMIS1521GA
>
Stored Procedures
> dbo.BAEImisNameSecurityGroupsSave
Properties
Parameters
SQL Script
Uses
Properties
Property
Value
ANSI Nulls On
Quoted Identifier On
Parameters
Name
Data Type
Max Length (Bytes)
@Id
varchar(10)
10
@securityGroup
varchar(30)
30
SQL Script
create
procedure
[dbo]
.
[BAEImisNameSecurityGroupsSave]
@Id
varchar
(
10
),
@securityGroup
varchar
(
30
)
as
UPDATE
Name_Security_Groups
SET
SECURITY_GROUP
=
@securityGroup
WHERE
ID
=
@Id
GO
Uses
[dbo].[Name_Security_Groups]
dbo